The user is now engaged in defining where outer versus inner joins should be used , and how to group details to provide the required aggregates 现在用户专注于定义应当在哪里使用“外部”联接与“内部”联接，以及如何对详细信息进行分组以提供所需的聚合。
Outer joins are treated differently from inner joins in that the optimizer does not try to rearrange the join order of outer join tables as it does to inner join tables Outer join与inner join的处理方式是不同的：对于inner join表，优化器会尝试重新排列联接顺序，而对于outer join表则不会。
Next time i ll continue with an article on the use of sql queries to build complex queries such as joins , inner joins , master - detail relations , and updates on these joins 下一次，我将继续用一篇文章说明如何使用sql查询来构建复杂的查询，如joins 、 inner joins 、 master - detail关系，以及这些joins的更新。
Specifies that all rows from the left table not meeting the join condition are included in the result set , and output columns from the other table are set to null in addition to all rows returned by the inner join 指定在结果集中包括左表中所有不满足联接条件的行，并在由内部联接返回所有的行之外，将另外一个表的输出列设为null 。
In a media set using tape backup devices , the first tape in a media family . inner join an operation that retrieves rows from multiple source tables by comparing the values from columns shared between the source tables 在事务复制中使用的一种功能，用于提供一种简便方法来测量滞后时间并验证发布服务器、分发服务器和订阅服务器之间的连接。
Specifies all rows from the right table not meeting the join condition are included in the result set , and output columns that correspond to the other table are set to null , in addition to all rows returned by the inner join 指定在结果集中包括右表中所有不满足联接条件的行，且在由内部联接返回的所有行之外，将与另外一个表对应的输出列设为null 。
In other words , it may be possible that applications fully exploiting cmrs could perform better than the code your average jdbc programmer is willing to write i hate to even look at sql with inner joins - especially when someone else wrote it ! 换句话说，就是充分利用了cmr的应用程序可能要比普通jdbc程序员愿意编写的代码执行的更好（我甚至讨厌看到使用内部连接的sql尤其是看到别人编写它的时候！ ）
But with full exploitation of cmrs , the application can sometimes be tuned with simple object navigation path expressions to issue just one sql statement with zero or more inner joins to handle multi - cardinality navigations ; my friend stacy calls these " honking big " joins 但通过充分利用cmr ，应用程序有时可以用简单的对象定位路径表达式来协调，以发布仅仅一个sql语句（使用零个或者更多的内部连接来处理多基数定位；我的朋友stacy将这些连接称为" honking big "连接） 。
